2013-04-09 - 5910.200 - Rel Notes - Contracts - Release 027 #BIReleases2013

Release Notes:

5910.200 - Contracts - OSA175

Admin Info

Purpose
 Including Contract Information in OSA175 report
Release No
 027
Submitted
 04-09-2013
Submitted by
 Mallareddy
Source/Destination Systems
 IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BO BI 4.0 Dev Environment
Release Sent To
 Mark Harris
Object(s) Created By
 Mallareddy
Object(s) Tested By
 Naga Brahmam R

Report Name

OSA175 - Open Orders by Sales Rep and Customer

BEx Query

ZMP_OOCON_Q007

NEC Crystal Reports Standards Check

1. OSA175 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. OSA175 NEC CR checklist has been sent to NEC and also attached here for reference:
OSA175 NEC CR Standard Check List.xlsx

Dynamic Group 1:

Test Conducted

Dynamic Grouping Parameter(1) and Group Name: Sales Rep > Customer > Period > DOC Number

Summary Level Check

Test Conducted

Group: NE Retail - NE > NEW ERA CAP CO LTD EURO - 1004352
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Number of Orders
 33
 33
 Pass
2
 Confirmed Qty
 44
 44
 Pass
3
 Customer Currency
 1220
 1220.43
 Pass
4
 Sales Org Currency
 1031
 1031.02
 Pass
5
 Corporate Currency
 1562
 1562.03
 Pass

Second Level Check

Test Conducted

Group: Benyben - BY > BENYBEN SL -1013332 > June
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Number of Orders
 1
 1
 Pass
2
 Confirmed Qty
 564
 564
 Pass
3
 Customer Currency
 4,681
 4,680.60
 Pass
4
 Sales Org Currency
 3,089
 3,088.73
 Pass
5
 Corporate Currency
 4,681
 4,680.60
 Pass

Third Level Check

Test Conducted

Group: Caryl Herron -CF > FOOTBALL NORTHWEST LLC - 1012503 > August > 1416186
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Number of Orders
 0
 0
 Pass
2
 Confirmed Qty
 1,728
 1,728
 Pass
3
 Customer Currency
 39,726
 39,726.00
 Pass
4
 Sales Org Currency
 39,726
 39,726.00
 Pass
5
 Corporate Currency
 39,726
 39,726.00
 Pass

Detail Level Check

Test Conducted

Group: Bobby Vann - BB > WALMART - 1012705 > July > 1461968 > 10796669
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Customer Currency
 107
 107.40
 Pass
2
 Sales Org Currency
 107
 107.40
 Pass
3
 Corporate Currency
 107
 107.40
 Pass

Dynamic Group 2:

Test Conducted

Dynamic Grouping Parameter(2) and Group Name: Sales Organization > Product Group > Customer > Period

Summary Level Check

Test Conducted

Group: Dave Aichinger - DA > Headwear
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Number of Orders
 8
 8
 Pass
2
 Confirmed Qty
 74,410
 74,410
 Pass
3
 Customer Currency
 7,32,421
 7,32,420.66
 Pass
4
 Sales Org Currency
 7,32,421
 7,32,420.66
 Pass
5
 Corporate Currency
 7,32,421
 7,32,420.66
 Pass

Second Level Check

Test Conducted

Group: Gerry Cruz - GD > Apparel > GOLD COUNTRY INC -1007387
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Number of Orders
 6
 6
 Pass
2
 Confirmed Qty
 2,336
 2,336
 Pass
3
 Customer Currency
 38,042
 38,042.04
 Pass
4
 Sales Org Currency
 38,042
 38,042.04
 Pass
5
 Corporate Currency
 38,042
 38,042.04
 Pass

Third Level Check

Test Conducted

Group: Joseph Gomes - JG > Accessories > ATHLETES FOOT - 1010609 > 201304
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Number of Orders
 0
 0
 Pass
2
 Confirmed Qty
 12
 12
 Pass
3
 Customer Currency
 226
 225.60
 Pass
4
 Sales Org Currency
 226
 225.60
 Pass
5
 Corporate Currency
 226
 225.60
 Pass

Detail Level Check

Test Conducted

Group: Nikki Beck - NB > Headwear > 3 HS SPORT SHOES - 1008052 > 201304 > 70012654 -5950
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Customer Currency
 1,990
 1,988.58
 Pass
2
 Sales Org Currency
 1,990
 1,988.58
 Pass
3
 Corporate Currency
 1,990
 1,988.58
 Pass

Reference Document(Specification)

2013-03-15 - 5910.200 - Spec - Contract Reports